play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
Fali@
FaliA
HBAM3016AUG95
Keith Proctor
Pro 3.0F!
Pro 3.0M1
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
tivity Log
Go to Address
Go to Checking Account
Go to Contacts
Go to Dollar Amount English
Go to Invoices
Go to Invoices 2
Go to Job Application
Go to Letter
Go to Line Checks
Go to Line Items
Go to Memorandum
Go to Messages
Go to Personnel Records
Go to Phone Numbers
Go to Products
Go to Purchase Orders
Go to To Do List
Go to Report Menu
Go to Reports in Contacts
Go to Reports in Invoices
Go to Reports in Parts
Print Help Documentation
Close File
Verify Password
3/10/99
COMPANY ADDRESS
COMPANY CITY
COMPANY LOGO DISABLED
COMPANY LOGO PLAIN
COMPANY NAME
COMPANY STATE
COMPANY ZIP CODE
COMPANY ZIP CODE BARCODE
DATABASE NAME
DOCUMENTATION
E MAIL ADDRESS
FAX LOGO
FAX NUMBER
LAYOUT NAME
LETTER BODY DISPLAY
LETTER CLOSE
LETTER GRAPHICS
LETTER HEAD DISPLAY
LETTER ID
LETTER LOGO PLAIN
LETTER SERIAL
LETTER TYPE
LOCAL LETTER ID
LOGO LOCATION
PASSWORD
PHONE NUMBER
PRINT CHOICE
REASON FOR LETTER
USER NAME
A User NameB
Company NameB
Company AddressB
Company CityB
Company StateB
Company Zip CodeB
Letter Logo PlainB
Company Logo PlainB
Company Logo DisabledB
Fax LogoB
Layout NameB
Database NameB
Letter SerialB
Reason for LetterB
A Letter IDB
Letter TypeB
Logo LocationB
Letter CloseB
Local Letter IDB
Macintosh 01 User
FILES INCLUDED:
* Description included below.
** Related to each other (no description available). This files are used to keep track of checking account, and print laser checks (Checking Account File performs a script related to Dollar Amount-English file to create the dollar amount in words). It is also used to keep track of purchase orders. Please note that in any field named Contact No. or Contact I.D. or Account Number, you must type the account number from the Contacts database.
s. Please note that in any field named Contact No. or Contact I.D. or Account Number, you must type the account number from the Contacts database.
Letter GraphicsB
Letter Head DisplayB
= "Top Left"
= "Top Center"
= "Top Right"
Top Left
Top Center
Top Right
Letter Body DisplayB
1) = "Block"
Block
DocumentationB
Print ChoiceB
Fax NumberB
Phone NumberB
E Mail AddressB
Company Zip Code BarcodeB
PasswordB
A Main Menu
Preferences 1
Documentation
Preferences 2
Preferences 3
Preferences 4
Print Documentation
Password
A Main MenuB
1cZccJ9RZkcZRc))1
19B9R9)
))119RJBR91BB1
B9BJ91JZskk{cJJRRJJZcZJ
c{sk{cRssc991
11B99B
))1JZJJB))19919R911991191
19119
1JcZcJ9RZkcZRcB))1
19B99R9)11)
9RBR91BB1
B9BJ91JZsskkcJJRRJJZcZJR
{sk{cRsscB991))11B99B
))1JZJJB
1919R9119911991
RcRRB9JJ9
!)19JJZJ9BRRZZRJBJR
B.9))1))191B)!191!
!1)!)
!1JBJJ91BR
scJRZZJRZZRBJRRc{sk{ZRkkZ
199BJ
R"B19BJJB9119RkckscRs
ks{{ss
ccRJJRRZkcZcJ9BJ
RJJZs
sskR9RZcZcscRZccRRZRB
RcRRZB9J9
Z9BRRZZRJBJRs
B"9))1))1B91B!191!
!!1!)
!1BJJ91BR
scJZZJRZZRBJ
c{k{ZRkkZ
9199B
R#B19BJRJB919RkckscRs
ks{{ss
kccRJRRZkcZcJ9BJRZZRJJZs
sskR9JRZZcscRZccRRZZRB
s cks
1B99JJ9
191)1
19BB91))1RcZcBBRZkZRZR9
1B99BJ
BRBJB)191
11)11
1B9JJ19Rc{kksZ
JRccZJRZcc
kkskJckcB11))
9B191
9JRBJ9
199JJ9
J/RcRJJ)9B9)!)!!)119JJRRB9JRckkcRJJ{
1 91)91
!!)11!))
)9JBJJ99JRkccsZ
RZZRBJRZk{kcskJZcRB
RRJRR91BJRRJB11BRkcssZc{
B9JZkkcZRRZs{kscBJRkccssc
ZZRBB
J0RcRJRJ)99)!)!!)119JRJRB9JRckkcRJJZ{
1 9B1)9
!)!)1!))
!))!!
)JBJJ99JRkccks
RZZRBJRZZk{cskJZcRB
RRJRR91BJ
J11BRkcssZc{
kZZJJ
B9JRZkcZRRZs{kscBBJRccssc
ZcZRBBJJR
skskks{
{Zs{skZ
c kks{{kssZcZcksskZcs
skskks{
Zs{skZ
ksks{kssZcZck
@991RJRJJZJRZB119BRJRB119JkkskZZ{
skkRRJRZc
kcZcJ99Rcsksc
R!s{kk9BRckcs
scZZccRJB9BJRZJBBJR9!)
BRJRJ99BRksckZRJRk
#kZRJJB91)!)19B1))1!
!)1))1))1
)1)1!
1JJRB19JZkck{Z
ZZRJBBJRcscZksRJ
B@991BRJRJZJRZB119BRRJB119JkkskZZ{
skkcRRJRc
kcZcJ99BRcksc
R%s{kkR9BRccs
scZZccZRJB9JRZ
kcZccZZck{{s
c{{sscck{
kcZccZZck
c{{s{scc{
19BB91))RcZkcBBRZkZRZ9
1B99J1
))11BRBBJB)191
11)11
1B9JJ19RckkssZ
JRccZJZccs
kkskJckc11))
9B191
9JRBJ9))
{kZRRZcs
cRJB99BRccs{RZJk{kscJJZ
{scRJ99BRR
{kkcks
{kZZcZk
{kkcks
{kZZcZk
1JJ9B9)1BcZcRR9RckZcJ11)1
1B9RB
1J919BJ1
1)1))1)11
BBJB19Rskk{cZRRZ
ZJRck{kcks{ZJBJ11)199119JB19
1BJBJ9
RZBB))19BBJZJB
1JJ9B91)1BZcRR9RckZcZJ11
1B9BR
1BJ99BJ1
1)1)1)11
BBJB19RcskkcZRRZ
ZJJRckkcks{ZJBJ911)19119JB19
1BBJ9
RZBB1))19BJZJB
11BJRZJBBJ9)!)
97BJRcJ99BRksckZJRk
kZRJRJB91)!)19B))19!
19))1
!1JJRB19JZkc{kZ
ZZRJBBJRscZZksRJ
{skks
{skkZcs
1R91J
RkckcJJZ
RRJB91
1)11))1B
RJJB91
1JJZR9Bs{{ss
skcRJJZsscZcs
1 BJJBJJBB91
1R99JR11)BRB9))9J
1R91JJ
RckcJJZ
ZRRJ91
1)11))1B
RJJB91
9B11BJ91
1JJZR9BZs{ss
ZscZcs
BJBJJBB91
199JR11)BRBJ9))9
119BRRB9BJB9)!!
!)9BBJJ
Z{cZkRZR{
{{skZRJ91
)99))191)!
!1B9BB
!9!19!)!BRJZRBBRk
{sskZRJ
JkRRZkscRJB
RJB9911ZJBRR9B9Zss
{kRRZcss
cRJB9BR{ccs{RZJk{kcJJZs
BRRB9BJRB)!!
!)9BBJJ
Z{cZksRZR{
{{sZRJ91
)'11)!
!1B99BB99)!
!9)!19!!BRJZRBBRk
{sskZRJ
JckRRkscRJB
BJZZR
RJB9911BZJBR9B9Zss
119))19JBJRJBJJ91
B1)19JB91
BJRZJ1k
{{s{{scRJJRk{cZcs
BRB119BB1
BJ9BcB
JRJ1)1J
ZRJRJ1
BB19Z911BkksZ9RkkcZRRB91
119))19JJBJJBJJ91
1B1)9JB91
191))11
BJRZJ1Rk
{{s{{scR
RkcZcs
sscRB
BB119BB1
J9BcB
JRJJ1)J
ZRJRJ91
199JRB99JBB91)!!)9JB99BRJ
kkZccRZc
{{kcZRJ9)
19!)1911)!!
!1B11
)!)B1!)1JRRZJ9Rckks{skskcRJ
kRJRcskcRJB99BcR
RRJB91991RJBBZB9BJks{
{RRZk{k
Z$ccRB
B9BBJkkZk
cRRZs{sZBZk{{s{
{s{sRJB
JRB99JRB91)!!)9JB99BRRJ
{{kZRJ9)
19)!)
!1B911991!
)1!)B!)1JRRZJ9RcksksskskcRJ
B,ZkRJcskcRJB99BRcRJJRRJB919919RJBZB9BJks{
{kRRZkk
ccRBB9
B;JkZk
cRRZs{ssZBk{{s{
{s{scRJB99JR
{skks
{skkZcs
9BJJB91)
)9B91)1ZB9
B&JRJZ{ccsZRZ{
{{cRRZJ9))!!
)B!)1
9.1)!
!1B)!)1B)
!))99))1BRZcRBBZkksskccscRJ
9kRJRZ
k(cZRB9BcJB99JZB191191BZJBRRB9BZs{
cJRk{cRJJRkJ9B99JBZ{kk{sZRRk{{kRRc
sM{{skksRJB991BZB99BJJB91)
)9B91)1BZB9BBJRJZ{cc{sZRZ
{{cRZJ9))!!
)B)!)1
9#1)!
!1B1)!)1)
!9))9))1BRZcRBBZ
skccscRJ
9JkRJZ
k(cZRB9BRcJ99JZB1911991BZBRRB9BZs{
{cJRkcRJJRkJ9B99BJB{kk{sZRRk
{{skkscRJB91BZ
{skkcs
#{skZk
sZcZZccZkss
{skkcs
#{skZk
{sks{sZcZZccZk
BB19911BckksZ9RkkcRRB991
g a label layout, see the FileMaker Pro documentation.
Change or add to the values in the pop-up lists for Contact Priority, Type, Phone Number Locations, or Personal Title.
INVOICES
Description
Use this file to create and keep track of invoices for your customers. The Invoices database allows you to bill a customer for products they have purchased. Product information is looked up from the Products database and customer information is obtained fro
"%UR
UD33D
wable from the Contacts file because there is relationship between the two files.
Shipping Information Click on the icon for shipping details to enter information such as the shipment location, cost, weight, carrier type, priority, and tracking number.
Products Purchased Type in a product ID from the Products database in the first available row. Or click on the right part in the first available row to activate a script to find a specific product. After you find t
1)1R99J119RkkskJJZccRR9
!)!!))!
1191))1BBJJB9BJ91
J1)19
1))11
1RRZRBZkss{{
scZRRJc
sc9)1BR91))1B
1RBBRR
BRRB11B
RRJBBJ1
1)1R99RJ119kkskJJZccZRR911
!)!!))!
1191))1
JB9BJ91
1RRZRBBZks{{
JccZcs
scR9)1B91))1B
RBBRR
RRJBBJB1
191BZB9
e products list.
How to customize this solution
Change or add to the values in the pop-up lists for Carrier, Shipping Priority, Payment Method, and Credit Card Type.
ACTIVITY LOG
Description
Use this database to track messages and contacts with your customers. This file is related to the Customers database.
How to use this solution
Anytime you wish to track correspondence with a contact, go to the Contacts database, find a contact, and click the N
D@
D@
the Notes field and select an appropriate Action Status and Action Type.
Letter Entry To create a letter, type the contents of the letter in the Letter Contents field and click the Print Letter button to print a copy of the letter.
Fax Entry To create a fax, type the contents of the fax message in the Fax Message field and click the Print Fax button to print a copy of the fax.
ADDRESSES
Description
This file is related to contacts and keeps the information about address, company na
DDDDDD
the Invoice database based on the Product ID.
ENTERING INFORMATION
Product Information Enter the product type, a short description, long description, short description in Spanish, the cost, the selling price, other charges cost such as fee for a returned check and the unit weight of the product.
General Comments Enter any notes on the product here.
Vendor Information Type in a contact ID from the Conta
wwwwww
one. For instance, you can st
ore phone numbers for work, home, school, mobile, and other locations as well as internet addresses.
How to use this solution
Phone numbers are always entered from the Contacts database but are stored in this file to allow for an unlimited number of contact phone numbers.
TO ENTER A PHONE NUMBER
- Go to the Contacts database and find or create a contact record.
- Type a phone number into the first available space in the phone number list.
A new phone number record will be created and
wwwwww
ffffff
333333
""""""
wwwwww
DDDDDD
333333
%US31
%US30
product ID into the first available space in the list of products purchased.
A new line item record will be created and stored in the Line Items database. Because the Line Items database is related to Invoices, all line items fo
#4EWp
"4EVx
#3EVg
"4DUg
#3EVg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
lick on the Letter button and type the letter you wish to send.
This letter will be stored in the Letters database and is logged as an activity. Because the Letters database is related to the Activity Log file, all letters for a particular contact can be viewed from the Contacts database.
* All calculations are faster than any previous version.
* Most of the scripts have been "tuned up" for speed.
This business solution is shareware. After paying the corresponding fee, you are allowed to modify it in any form to adapt it to your company needs, but you are not authorized to sell it or distribute it, e
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
Include your company name, contact name, address, phone & fax number and e-mail address. Your password will be sent to you by e-mail and first class mail along with your payment receipt.
Payments send via postal mail take tim
wwwwww
ffffff
UUUUUU
DDDDDD
333333
ing the shareware fee:
While we hope you don
t find any bugs, if you do let us know!
The more information you can include the more likely we are to be able to fix it. Report any bugs or send comments and question by e-mail to: elsoldemex@aol.com or by fax at: (718) 460-3106.
Want more information or updates?
Visit our web page at:
http://members.aol.com/elsoldemex
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
UTdUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwxwwxw
wwwwww
ffffff
UUUUUU
DDDDDD
333333
Preview and Print\
718-460-3106]
718-460-0349^
SolDMexico@aol.com_
\1135552422\`
01152232
Preferences 1B
_>Main Menu - Click a button to access a database or preferences
Preferences
Activity Log
W Addresses
Contacts
Dollar Amount - English
Invoices
Job Application
Letters
Line Checks
Line Items
Memorandum
Messages
Phone Numbers
Products
To Do List
Click on any button to open that file and start working.
Click on the Info button for more information, help and shareware fee for this business solution database.
Click on any button to open that file and start working.
Click on the Info button for more information, help and shareware fee for this business solution database.
Files used for storage purposes
orTo return to this menu press [
] and [1] keys from any file,
or go to the script menu and select [Go to Main Menu]
Purchase Orders
Checking Account
DocumentationB
Preferences
Main
Address
Standard Letter
Miscellaneous
Company Name
Company Address
Company City
State
Company Zip
ypCompany Name and Address - enter your company address information as you would like to see it appear on letters.
Your Company Address
{ Your Name
|uUser Name - enter your name as you would like to see it appear on letters, invoices, and in contact history records.
<Letter Logo - paste a graphic into the Letter Logo field to add your own logo to the top of letters printed from the Integrated Solution. The Standard Letter preference panel has a Logo Location preference which can be used to display the letter logo at the top of a letter towards the left, center, or right margin.
Company Logo Plain - paste a graphic into this field to display your own logo at the top left corner of each of the Integrated Solution files.
Company Logo Disabled - paste a graphic into this field to display a disabled version of your logo at the top left corner of the Integrated Solution files when there is a custom dialog showing (eg. when no records are found).
Preferences
Preferences 4B
Preferences
Main
Letter Type
Logo Location
Letter Close
mmSelect a location for the logo at the left, center, or right side at the top of letters that will be printed.
,Select a letter style for the formatting of paragraphs in letters. Block letters do not use indents; whereas, modified style letters have a one tab indent at the beginning of each paragraph. Formal letters use the full name of the addressee; whereas, informal style letters use only the first name.
Select from 8 choices for a closing (or
complimentary close
) for letters; e.g.,
Respectfully yours,
Yours truly,
Best wishes,
etc.
Address
Standard Letter
Miscellaneous
Preferences
Print DocumentationB
Sample Solution documentation
A!Integrated Solution documentation
Page ##
Preferences
Main
Miscellaneous
Standard Letter
Address
Tax Rate Option
Tax Rate Option - Enter the tax rate that should be used for calculating invoice totals. Values should be entered as a decimal such as .0825.
Tax Rate
Printing Options
Print Options - select an option for printing or previewing a report to control how reports are displayed. You can choose print only, preview only, or preview and then print.
Print Choice
Product ID Option
Product ID
{Product ID Option - Select the type of ID to be entered for a product when a new product record is created. Sequential Serial Number - a number that starts at 1 and is incremented by one. Text and Sequential Number will enter the first character of the first 3 words in the short description and a sequential number. Selecting None will allow you to enter your own Product ID.
Preferences
PasswordB
Please enter your password
click on the continue button
or press enter WHEN FINISH...
IF YOU
RE EXPERIENCing PROBLEMS DOING THIS REQUEST,
GO BACK TO THE ORIGINAL FILE AND TRY to do IT AGAIN.
PLEASE NOTE THAT ALL REQUESTS AND/OR TRANSACTIONS
ARE NOW BEING RECORDED, DON
T TRY TO OVERRIDE THE PROCEDURE,
the system will not accept unauthorized requests or transactions.
This files are not needed for this business solution, some of them are included with the FileMaker Pro Version 3.0 and later. (The shareware fee is for the rest of the files).
Activity Log*
Addresses*
Checking Account**
Contacts*
Dollar Amount - English**
Invoices*
Job Application***
Letters*
Line Checks**
Line Items*
Main Menu*
Memorandum***
Messages***
Phone Numbers*
Products*
Purchase Orders**
To Do List***
Below you will find the documentation for each of the files included in this
relational sample solution. You may find that this solution will work as is but may wish to make changes to customize this solution for your business. Either way this documentation is included to help you use this solution. You will find that some of this documentation can be found in each of the files on special help layouts. Click on the help button in each file to see this general help.
MAIN MENU
Description
Use the Main Menu database to navigate to the solution files and set gen
FaliA
eral preferences.
How to use this solution
To set preferences for solution files.
- Click on the Preferences button.
- You can enter your address, a company logo, or set the default style for creating new letters.
Address
User Name - enter your name as you would like to see it appear on letters, invoices, fax cover sheets, statements and all related printed form.
Company Name and Address - enter your company address information as you would like to see it appear on letters, invoices,
fax cover sheets, statements and all related printed form.
Logos
Letter Logo - paste a graphic into the Letter Logo field to add your own logo to the top of letters printed from the Integrated Solution. The Logo Location preference can be used to display the letter logo at the top of a letter towards the left, center, or right margin.
Company Logo Plain - paste a graphic into this field to display your own logo at the top left corner of each of the Integrated Solution files.
Compa
ny Logo Disabled - paste a graphic into this field to display a disabled version of your logo at the top left corner of the Integrated Solution files when there is a custom dialog showing (eg. when no records are found).
Standard Letter
Logo Location - select a default location for the Letter Logo at the left, center, or right side at the top of letters printed from the Integrated Solution.
Letter Type - select a default letter style for the formatting of paragraphs in letters. Four
choices are available: block/modified and formal/informal. Block letters do not use indents whereas modified style letters have a one tab indent at the beginning of each paragraph. Formal letters use the full name of the addressee whereas informal style letters use only the first name.
Letter Close - select from one of seven choices for a default closing statement for letters such as
Respectfully Yours
Your Truly
Best Wishes
, etc.
Miscellaneous
Printing Options - select an
option for printing or previewing a report to control how reports are displayed. You can choose print only, preview only, or preview and then print.
Tax Rate - enter the tax rate that should be used for calculating invoice totals. Values should be entered as a decimal such as .0825. Most of other files (e.g. invoices) uses their own tax rate which can be specified as .0825 but will be displayed as 8.25%.
Product ID - select the type of ID to be entered for a product when a new pro
duct record is created. Sequential Serial Number - a number that starts at 1 and is incremented by one. Text and Sequential Number will enter the first character of the first 3 words in the short description and a sequential number. Selecting None will allow you to enter your own Product ID.
How to customize this solution
Add your own buttons to the main menu layout to open other databases that you use.
CONTACTS
Description
Use this file to keep track of people you need to contact s
uch as customers. The Contacts database contains information such as a customer
s name, phone number, address and several more options such as contact type, open account information (if you intend to open an account for a contact). Please note that this file works along with other related databases such as addresses, phone numbers, etc. The file includes predefined reports for printing customer profiles, phone lists, and mailing labels.
How to use this solution
ENTERING INFORMATION
ontact Information
Phone, Fax & Internet Enter the company name, contact name and address for a contact.
Phone Number Type in phone numbers to reach a contact, select from the list of locations such as home, work, or school, and type the times at which the contact can be reached. You can enter as many phone numbers as needed for any contact by typing a new phone number in the last available space next to the phone icon. Clicking the phone icon will use your modem or speaker to dial the ph
one number.
Action History Click on any activity in the list to view all the information for that activity. To enter a new activity for the current contact, click on the New Activity button. An activity is a type of correspondence that should be performed for the current contact such as a phone call, fax, or letter. Because each activity is stored in the Activity Log database, you can enter as many activities as needed for any contact. To view additional activities for a contact, click o
n the scroll bar to the right of the activity list.
Contact Status For the current contact select the Kind of Account, Contact Type, level of priority (high, medium, and low), the type of contact (business, personal, vendor), and who referred the contact. Information about the total amount of purchases for this customer is automatically updated from the Invoices database. Similarly, the date created, date modified, and created by fields are automatically entered. You can also enter more i
nformation as you want to such as social sec. no. tax id. bank name, etc.
Open | Credit Acc
Information On SR Number you must enter an account number (the number that appears on the right top side of the form) from a previous contact record created, this is intended to control the commissions and sales representative activities. SR Name is entered automatically (last name of the sales representative) commission rate is the percentage rate that you will pay for commission to the sales repre
sentative. Total Com. is the total commission paid to the sales representative and is calculated automatically from the invoices record, as well as Due by SR which should be the total amount due from the sales representative to your company. On language you can select from Spanish and English this is used depending on what kind of forms this database is going to print, depending on the language selected this solution will print the correct form. Authorized you can modify the values at any
time. Terms: you specify the terms for this account. CR Limit is the credit limit you assign to this account. Due by Client, Available Credit & Purchases are calculated automatically from the Invoices file.
How to customize this solution
If the built-in label report does not match the labels you use, edit the existing layout or create a new layout. Choose Layout from the Select menu. Select New Layout from the Edit menu, click the Labels radio button and choose the proper Avery label in
the menu. For details on formatting a label layout, see the FileMaker Pro documentation.
Change or add to the values in the pop-up lists for Contact Priority, Type, Phone Number Locations, or Personal Title.
INVOICES
Description
Use this file to create and keep track of invoices for your customers. The Invoices database allows you to bill a customer for products they have purchased. Product information is looked up from the Products database and customer information is obtained fro
m the Customer database, and each item purchased is stored in a file called Line Items. The Invoices database ties all this information into a single form which you can print as invoice, invoice past due, statement, etc. You can select what kind of form to print from the script menu.
How to use this solution
ENTERING INFORMATION
Purchaser
Information Type in a contact ID from the Contacts database or click on top of the Account Number field to activate the button. Company name and addre
ss is automatically viewable from the Contacts file because there is relationship between the two files.
Shipping Information Click on the icon for shipping details to enter information such as the shipment location, cost, weight, carrier type, priority, and tracking number.
Products Purchased Type in a product ID from the Products database in the first available row. Or click on the right part in the first available row to activate a script to find a specific product. After you find t
he product you are looking for click on the (Select this Product) button on the right top part of the form. Product price and description are automatically looked up from the Products database. Also enter the quantity of product purchased. Because each product purchased is stored in the Line Items database, you can enter as many products as needed for an invoice by typing a new product ID in the first available space in the list. To view additional products purchased for an invoice, click
on the scroll bar to the right of the products list.
How to customize this solution
Change or add to the values in the pop-up lists for Carrier, Shipping Priority, Payment Method, and Credit Card Type.
ACTIVITY LOG
Description
Use this database to track messages and contacts with your customers. This file is related to the Customers database.
How to use this solution
Anytime you wish to track correspondence with a contact, go to the Contacts database, find a contact, and click the N
ew Activity button. Choose which type of action to take: a call, letter, or fax. Click OK and enter the information for the call, the contents of the letter, or the message for the fax.
Note that much of the work of entering your address and the customer
s address has already been done. You can edit your address information in the Main Menu preferences. The customer
s information is taken from the Contacts database.
ENTERING INFORMATION
Call Entry Enter notes about the phone call in
the Notes field and select an appropriate Action Status and Action Type.
Letter Entry To create a letter, type the contents of the letter in the Letter Contents field and click the Print Letter button to print a copy of the letter.
Fax Entry To create a fax, type the contents of the fax message in the Fax Message field and click the Print Fax button to print a copy of the fax.
ADDRESSES
Description
This file is related to contacts and keeps the information about address, company na
me, contact name and zip code, it is also used to generate bar codes for all correspondence that will be printed and keeps track of fields modified, date time, field name and user who modified the field values.
PRODUCTS
Description
Use the Products database to enter information on products that you sell. This product information is used by the Invoice database to look up prices and product descriptions when creating a customer invoice.
How to use this solution
Enter a record for each pr
oduct that you sell. Information on product price and description is looked up in the Invoice database based on the Product ID.
ENTERING INFORMATION
Product Information Enter the product type, a short description, long description, short description in Spanish, the cost, the selling price, other charges cost such as fee for a returned check and the unit weight of the product.
General Comments Enter any notes on the product here.
Vendor Information Type in a contact ID from the Conta
cts database in the Vendor ID field. Company name and address is automatically viewable from the Contacts file because there is relationship between the two files.
Inventory Type in the necessary information.
PHONE NUMBERS
Description
This file is used to track customer phone numbers and is related to the Customers database. Having a separate database for phone numbers allows you to store as many different types of phone numbers as you need to reach someone. For instance, you can st
ore phone numbers for work, home, school, mobile, and other locations as well as internet addresses.
How to use this solution
Phone numbers are always entered from the Contacts database but are stored in this file to allow for an unlimited number of contact phone numbers.
TO ENTER A PHONE NUMBER
- Go to the Contacts database and find or create a contact record.
- Type a phone number into the first available space in the phone number list.
A new phone number record will be created and
stored in the Phone Numbers database. Because the Phone Numbers file is related to Contacts, all phone numbers for a particular person can be viewed from the Contacts database.
How to customize this solution
To change or add to the values for the Phone Number Location field, go to the Contacts database and edit the value list there.
LINE ITEMS
Description
The Line Items database is used to track individual items purchased by a customer and is related to the Invoice database.
How to
use this solution
Line items are always entered from the Invoices database but are stored in this file to allow for an unlimited number of items to be purchased.
TO ENTER A LINE ITEM
- Go to the Invoices database and find or create an invoice record.
- Type a product ID into the first available space in the list of products purchased.
A new line item record will be created and stored in the Line Items database. Because the Line Items database is related to Invoices, all line items fo
r a particular invoice can be viewed from the Invoices database.
LETTERS
Description
Use this database to write letters to send to people in the Contacts file.
How to use this solution
Letters are always entered from the Activity Log database but are stored in this file to allow for an unlimited number of letters.
TO ENTER A LETTER
- Go to the Contacts database and find or create the contact record.
- Create an activity by clicking on the New Activity button under Action History.
- Click on the Letter button and type the letter you wish to send.
This letter will be stored in the Letters database and is logged as an activity. Because the Letters database is related to the Activity Log file, all letters for a particular contact can be viewed from the Contacts database.
CLICK ON THE HELP BUTTON WITHIN THE MAIN MENU IN FILEMAKER INSTRUCTIONS
AND INFORMATION
What's new on version 2.0?
* Validates credit card numbers. It doesn't tell you whether the credit card has cleared the bank, but rather serves as a way to prevent typos. The algorithm is able to determine if the digits in the card follow the correct pattern. If the credit card number is invalid it will show a red note below the credit card number field as: "Credit Card Number: INVALID".
If the credit card number entered is correct it will only display "Credit Card Number" in black type.
* Print total number of pages in a statement. (i.e. PAGE 1 OF 15).
* All calculations are faster than any previous version.
* Most of the scripts have been "tuned up" for speed.
This business solution is shareware. After paying the corresponding fee, you are allowed to modify it in any form to adapt it to your company needs, but you are not authorized to sell it or distribute it, e
xcept a password protected version.
This preview version is fully functional, but without a password you won
t be able to modify any scripts or fields on some files (files marked with and (*) and (**) in the Main Menu Help Section).
Payment:
This business solution is shareware!
A Single user license $50.00 per user.
A Site License costs $150.00 and covers a building.
A World-Wide License costs $300.00 and it covers all locations for your organization.
to Pay:
Mail:
If you are paying with USD Check or Money Order you should send it to:
EL SOL DE MEXICO
132-31 59TH AVENUE, 1ST FLOOR
FLUSHING, NY 11355-5242
USA
f you pay via check, it must be a check drawn in US Dollars. Include your company name, contact name, address, phone & fax number and e-mail address. Your password will be sent to you by e-mail and first class mail along with your payment receipt.
Payments send via postal mail take tim
e to reach us and then up to 10 days for processing. Again, if you include a correct email address, you will hear from us when the order is processed. And we will send you the password so you can adapt any script or fields from this Integrated Solution Database.
Please include with your payment: your company name, contact name, address, phone & fax number and e-mail address. Your password will be sent to you by e-mail and first class mail along with your payment receipt.
To report a
ny bugs or have questions before paying the shareware fee:
While we hope you don
t find any bugs, if you do let us know!
The more information you can include the more likely we are to be able to fix it. Report any bugs or send comments and question by e-mail to: elsoldemex@aol.com or by fax at: (718) 460-3106.